Skip to main content

What’s New

Qrvey 8.7
Version 8.7 of the Qrvey platform is now available to customers! This version includes new features including area charts, the ability to pivot and export data, as well as numerous bug fixes and performance improvements.
Learn More
Qrvey 8.6
Version 8.6 of the Qrvey platform is now available to customers. This version includes several new feature enhancements and performance improvements.
Learn More
Required Update for 8.5.1
Attention 8.5.1 customers: for any 8.5.1 instance deployed prior to 08/05/2024, an update is required to ensure you are running the latest images.
Learn More
Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
Version: 8.3

Bar Chart

Use a Bar Chart to compare categorical aggregate values. For example, a bar chart can be used to compare the amount/percentage of a population that attends various categorical events. In Qrvey, users can create Horizontal or Vertical Bar Charts.

bar-chart

Creating a Bar Chart​

Bar Charts are used when you want to present a single value and a single category. To create a Bar Chart, drag and drop a data field from the Data Panel onto either the corresponding shelf or the canvas.

In the case below, we wanted to show the quantities in different statuses of shipments. We dragged and dropped status as Category and Quantity as Value. The chart orientation was changed from the default horizontal to vertical and the colors were customized to show canceled (red), shipped (green), and on-hold (yellow) shipments at a glance.

bar-chart

If you have more than one category you’d like to visualize, you can use a Multiseries Bar Chart.

Styling the Bar Chart​

In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.

General​

  • Tooltips - enable or disable Tooltips.
    • To show more than one value on mouseover, click on +Add Column:
      • Column - pick a value from the dropdown list. This can be any column, even if it is not used in the chart.
      • Display Values As - choose the aggregation type for each additional column you’d like to display in the tooltip (Sum, Average, Median, Count, Distinct Count, Minimum, Maximum).
      • Values Format- set the format of the values on the scale choosing between Default, Abbreviated, Decimal (set a number of decimals), Currency (choose the currency from the drop-down menu and set a number of decimals), Percentage (set a number of decimals), Scientific.
      • Remove - remove the tooltip column.
    • Header - add a header to the tooltip.
  • Max Data Points - set the upper limit of the bars you’d like to show in your Bar Chart. Controlling the number of bars helps you manage the clarity and organization of the chart - if you have too many bars, the chart can quickly become unreadable.

Styles​

  • Color Type
    • Single - all bars are the same color.
      • Color - change the color of the bars.
    • By category - each bar is colored based on its category.
      • Theme - set one of the predetermined themes for a more unified look of your charts.
      • Match colors across charts - unify the colors of each categorical value throughout the page and application.
  • Axis Labels - Show or hide the labels of the axes.
  • Orientation - Choose between the vertical or horizontal orientation of the bars.
  • Values axis (typically y axis)
    • Label - give the axis a custom label.
    • Values - show or hide values on the axis.
    • Values Rotation - if value labels are enabled, decide how you want them to be displayed. You can use this option to avoid overlapping labels.
    • Format - set the format of the values choosing between Default, Abbreviated, Decimal (set the number of decimal points), Currency (choose the currency from the drop-down menu and set the number of decimal points), Percentage (set the number of decimal points), Scientific. Values can also be formatted from the Values column pill.
    • Scale Type - the default scale type is Linear; however, a linear scale is not appropriate for data that is spread over a wide range. Use the Logarithmic scale to display numerical data over a wide range of values in a compact way.
    • Min Range - set the minimum value for the axis.
    • Max Range - set the maximum value for the axis.
    • Steps - Depending on how wide the axis range is, the default configuration could display a lot of tick marks, making it hard to read or analyze the chart. Intervals are set to Auto by default, meaning the chart will calculate the appropriate intervals based on the axis scale range and the dataset values. In the example below, we set the step to 100 units, so the chart will display a tick mark every 100 units starting from 0, resulting in only 3 tick marks. bar-chart It’s important to keep in mind that when the axis range is vast (e.g., 0 - 10,000,000), setting the “Steps” option to 1 will create 10 million tick marks, causing performance issues on the chart and probably blocking the browser. To avoid this situation, the chart will ignore the defined value and fall back to automatic mode.
  • Category axis (normally the X-axis)
    • Label - give the axis a custom label.
    • Values - show or hide values on the axis.
    • Values Rotation - if values are enabled, decide how you want them to be displayed.
  • Bar Width - bar width is set to Auto by default, meaning the system adjusts the percentage to what it sees as most adequate considering the size of the chart. If the width is set to 100%, the bars use up all of the chart’s space and there’s no gap left between them. Choose a width percentage other than 0 to decide the width of each bar and the gap between them. Setting the percentage to 0 will return the mode to automatic.
  • Data Labels - Show or hide the Value labels of your bars.
  • Borders - Show Value data labels in frames.
  • Shading - Shade the remaining space between the actual value and the top of the bar.

Sorting​

Like all XY Charts, you can sort by either the category or aggregated values from the column pills. If the column is not included in the chart, go to the Sorting section of the Configuration Panel and pick your desired column from the dropdown, and select the sorting direction.

For more information, see Sorting.

Layers​

Add a Trend Line or a Reference Line to your chart to allow users to visually compare the data against some set trend or reference value.

Format​

The Small Multiples feature is available in all XY Charts. You can apply Conditional Formatting to your Bar Chart.

Filters​

You can also add Filters to your data by expanding the Filters section in the configuration panel or by clicking on the Filters button in the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from End Users. These types of filters can’t be edited or interacted with in the view mode. For more information, see Filters.

For more on Bar Charts and other XY charts, watch the XY Chart video.